Tabela LBenefitPlanService

Definicja tabeli LBenefitPlanService

Name

LBenefitPlanService

Code

LBenefitPlanService

Comment

PL: Polaczenie benefitplanu z usluga
EN: Link between benefitplan and service


Przynaleznosc uslugi (opcji) do benefit planu. Tutaj okresla sie szereg atrybutów, m. in. cennik.
UWAGA: Przynalezec moze tylko grupa uslug lub usluga nie podpieta do zadnej grupy!

Atrybuty przynaleznosci uslugi (opcji) do benefit planu

PatientPartPercent - Udzial pacjenta w cenie
PayerPartPercent - Rabat od ceny FFS
usesFFSPriceList - Flaga czy BP jest rozliczany wg FFS czy ma swoje cenniki


Lista kolumn tabeli LBenefitPlanService

Name

Code

LBenefitPlanServID

LBenefitPlanServID

ServiceGroupID

ServiceGroupID

ServID

ServID

BenefitPlanID

BenefitPlanID

AgeBottom

AgeBottom

AgeTop

AgeTop

PatientPartPercent

PatientPartPercent

PayerPartPercent

PayerPartPercent

usesFFSPriceList

usesFFSPriceList

Sex

Sex

Notes

Notes


Kolumna LBenefitPlanServID tabeli LBenefitPlanService

Definicja kolumny LBenefitPlanServID tabeli LBenefitPlanService

Name

LBenefitPlanServID

Code

LBenefitPlanServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServiceGroupID tabeli LBenefitPlanService

Definicja kolumny ServiceGroupID tabeli LBenefitPlanService

Name

ServiceGroupID

Code

ServiceGroupID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ServID tabeli LBenefitPlanService

Definicja kolumny ServID tabeli LBenefitPlanService

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BenefitPlanID tabeli LBenefitPlanService

Definicja kolumny BenefitPlanID tabeli LBenefitPlanService

Name

BenefitPlanID

Code

BenefitPlanID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AgeBottom tabeli LBenefitPlanService

Definicja kolumny AgeBottom tabeli LBenefitPlanService

Name

AgeBottom

Code

AgeBottom

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AgeTop tabeli LBenefitPlanService

Definicja kolumny AgeTop tabeli LBenefitPlanService

Name

AgeTop

Code

AgeTop

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PatientPartPercent tabeli LBenefitPlanService

Definicja kolumny PatientPartPercent tabeli LBenefitPlanService

Name

PatientPartPercent

Code

PatientPartPercent

Data Type

FLOAT

Mandatory

No

Comment

 


Kolumna PayerPartPercent tabeli LBenefitPlanService

Definicja kolumny PayerPartPercent tabeli LBenefitPlanService

Name

PayerPartPercent

Code

PayerPartPercent

Data Type

FLOAT

Mandatory

No

Comment

 


Kolumna usesFFSPriceList tabeli LBenefitPlanService

Definicja kolumny usesFFSPriceList tabeli LBenefitPlanService

Name

usesFFSPriceList

Code

usesFFSPriceList

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Sex tabeli LBenefitPlanService

Definicja kolumny Sex tabeli LBenefitPlanService

Name

Sex

Code

Sex

Data Type

VARCHAR2(1)

Mandatory

No

Comment

PL: Plec
EN: Sex of the person
DE: das Geschlecht


Kolumna Notes tabeli LBenefitPlanService

Definicja kolumny Notes tabeli LBenefitPlanService

Name

Notes

Code

Notes

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Lista kluczy tabeli LBenefitPlanService

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LBenefitPlanService

Definicja klucza Identifier_1 tabeli LBenefitPlanService

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment